{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Нормы СанПиН","Сличительное меню","Примерное меню","Пищевая ценность"],"read":"whole","date_system":"1900"}

{"sheet":"Нормы СанПиН","index":0,"n_rows":53,"n_cols":4,"rows_kept":53,"merged":[[2,0,2,2],[4,0,4,2],[8,1,8,2],[28,0,29,0],[32,0,32,2],[34,0,34,2],[46,0,46,2]]}
["СанПиН 2.3/2.4 3590-20"]
[]
["Приложение 10"]
[]
["таблица 1"]
[]
["Суточная потребность детей в пищевых веществах и энергии детей"]
[]
["Название пищевых  веществ","Усреднённая потребность  в пищевых веществах для детей с 7 до 12 лет"]
[null,"Суточная норма","70-75% от суточной нормы при повышенных энерготратах"]
["Белки (г)",77,"53,9-57,75"]
["Жиры (г)",79,"55,3-59,25"]
["Углеводы (г)",335,"234,5-251,25"]
["Энергетическая ценность (ккал)",2350,"1645-1762,5"]
[]
["таблица 3"]
[]
["Рекомендуемое распределение калорийности между приёмами пищи в течении дня"]
[]
["Приём пищи","Доля суточной  потребности в энергии, %","Доля суточной потребности в ккал","+-5%"]
["Завтрак",{"v":0.25,"d":"25%"},587.5,"558,12-616,87"]
["Обед",{"v":0.35,"d":"35%"},822.5,"781,37-863,62"]
["Дополнительное увеличение при летнем отдыхе и повышенных энерготратах не менее 10%","10-15%","235-352,5"]
[]
[]
[]
["Приложение 12"]
[]
["Организация с дневным пребыванием в период каникул","8.30-14.30","завтрак и обед"]
[null,"8.30-18.00","Завтрак, обед и полдник"]
[]
[]
["Приложение 9 "]
[]
["таблица 1"]
[]
["Масса порций для детей с 7 до 12 лет"]
[]
["Каша, или овощное, или яичное, или творожное, или мясное блюдо(допускается комбинация разных блюд завтрака, при этом выход каждого блюда может быть уменьшен при условии соблюдения общей массы блюд завтрака)","150-200"]
["Закуска (холодное блюдо) (салат, овощи и т.п)","60-100"]
["Первое блодо","200-250"]
["Второе блюдо (мясное, рыбное, блюдо из мяса птицы)","90-120"]
["Гарнир","150-200"]
["Третье блюдо (напиток)","180-200"]
["Фрукты",100]
[]
["таблица 3"]
[]
["Суммарные объёмы блюд по приемам пищи ( в граммах не менее)"]
[]
["Завтрак",500]
["Второй завтрак",200]
["Обед",700]

{"sheet":"Сличительное меню","index":1,"n_rows":47,"n_cols":7,"rows_kept":47}
["День1","День2","День 3 ","День 4 ","День 5","День 6","День 7"]
["Завтрак","Завтрак","Завтрак","Завтрак","Завтрак","Завтрак","Завтрак"]
["Каша ячневая молочная","Каша геркулесовая молочная","Каша гречневая молочная","Каша Дружба молочная","Каша манная молочная ","Каша рисовая молочная","Каша пшенная молочная"]
["Яйцо отварное","Запеканка из творога","Омлет","Яйцо отварное","Сырники из творога","Бутерброд с маслом и сыром","Омлет"]
["Бутерброд с сыром","Бутерброд с маслом","Бутерброд с маслом и сыром","Бутерброд с сыром","Бутерброд с маслом","Какао с молоком","Бутерброд с сыром"]
["Какао с молоком","Чай с сахаром","Чай с урюком","Чай с лимоном","Чай с сахаром","Фрукт","Чай с урюком"]
["Фрукт","Фрукт","Фрукт","Фрукт","Фрукт",null,"Фрукт"]
[]
["2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак"]
["Сок ","Сок","Сок","Сок","Сок","Сок","Сок"]
["Оладьи","Кондитерское изделие","Кондитерское изделие","Булочка домашняя","Кондитерское изделие","Кондитерское изделие","Оладьи"]
[]
["Обед","Обед","Обед","Обед","Обед","Обед","Обед"]
["Салат из моркови с яблоком","Салат из огурцов и помидор","Салат из капусты","Салат из свеклы с черносливом","Салат из помидор с репчатым луком","Салат из моркови с яблоком","Салат из огурцов и помидор"]
["Суп гороховый на мкб","Борщ на мкб со сметаной","Суп с вермишелью на курином бульоне","Рассольник на мкб со сметаной","Щи на мкб со сметаной","Суп с клецками на курином бульоне","Суп картофельный с гречневой крупой"]
["Макароны отварные","Рис отварной","Картофельное пюре","Макароны отварные","Картофель тушеный","Гречка отварная","Рагу из птицы"]
["Котлета куриная","Рыба припущенная с овощами","Котлета из говядины","Гуляш из куриных грудок","Биточки рыбные","Гуляш из говядины","Хлеб ржаной"]
["Соус ","Хлеб ржаной","Хлеб ржаной","Хлеб ржаной","Хлеб ржаной","Хлеб ржаной","Компот из сухофруктов"]
["Хлеб ржаной","Кисель","Компот из свежих фруктов","Компот из сухофруктов","Кисель","Компот из свежих фруктов"]
["Компот из сухофруктов"]
[]
[]
["День 8","День 9","День 10 ","День 11","День 12","День 13","День 14"]
["Завтрак","Завтрак","Завтрак","Завтрак","Завтрак","Завтрак","Завтрак"]
["Каша геркулесовая молочная","Каша ячневая молочная","Каша манная молочная","Каша дружба молочная","Каша геркулесовая молочная","Каша гречневая молочная","Каша дружба молочная"]
["Яйцо отварное","Бутерброд с маслом и сыром","Сырники из творога","Омлет","Бутерброд с маслом и сыром","Яйцо отварное","Омлет"]
["Бутерброд с маслом","Какао с молоком","Бутерброд с сыром","Бутерброд с маслом","Какао с молоком","Бутерброд с сыром","Бутерброд с маслом"]
["Чай с лимоном","Фрукт","Чай с сахаром","Чай с урюком","Фрукт","Чай с лимоном","Чай с урюком"]
["Фрукт",null,"Фрукт","Фрукт",null,"Фрукт","Фрукт"]
[]
["2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак","2-ой завтрак"]
["Сок","Сок ","Сок","Сок ","Сок","Сок","Сок "]
["Кондитерское изделие","Кондитерское изделие","Слойка с сахаром","Кондитерское изделие","Кондитерское изделие","Оладьи","Кондитерское изделие"]
[]
["Обед","Обед","Обед","Обед","Обед","Обед","Обед"]
["Огурцы свежие","Салат из свеклы с черносливом","Салат из капусты","Салат из помидор с репчатым луком","Салат из моркови с яблоком","Салат из свеклы с черносливом","Салат из огурцов и помидор"]
["Рассольник на мкб со сметаной","Щи на мкб со сметаной","Суп картофельный  на мкб с гречневой крупой","Борщ на мкб со сметаной","Суп с вермишелью на курином бульоне","Рассольник на мкб со сметаной","Щи на мкб со сметаной"]
["Макароны отварные","Картофельное пюре","Рис отварной","Макароны отварные","Пюре гороховое ","Жаркое из куриных грудок","Картофельное пюре"]
["Тефтели из говядины","Кнели куриные","Рыба припущенная с овощами","Котлета куриная с соусом","Котлета из говядины","Хлеб ржаной","Биточки рыбные"]
["Соус ","Хлеб ржаной","Хлеб ржаной","Хлеб ржаной","Хлеб ржаной","Компот из сухофруктов","Хлеб ржаной"]
["Хлеб ржаной","Компот из свежих фруктов","Компот из сухофруктов","Кисель","Компот из свежих фруктов",null,"Кисель"]
["Кисель"]
[]
[]
["Отличия от основного меню других районов"]
[]
["Фрукты по 200 гр"]

{"sheet":"Примерное меню","index":2,"n_rows":262,"n_cols":8,"rows_kept":262,"merged":[[5,0,5,7],[6,0,6,7],[7,0,7,7],[9,3,9,5],[11,0,11,2],[30,0,30,2],[48,0,48,2],[66,0,66,2],[84,0,84,2],[102,0,102,2],[119,0,119,2],[136,0,136,2],[155,0,155,2],[173,0,173,2],[191,0,191,2],[210,0,210,2],[227,0,227,2],[244,0,244,2]]}
["Согласовано:",{"$nulls":5},"Утверждаю:"]
["Директор МБОУ \"Старо-Матаковская СОШ\"",{"$nulls":5},"Председатель СПОСПК  \"Эдем\""]
["Алькеевского муниципиального района РТ"]
["__________________ Тихонов С . Ю.",{"$nulls":5},"________________Турнина А. А."]
[]
["Примерное двухнедельное меню для организации сбалансированного питания детей в пришкольных"]
[" оздоровительных лагерях  с дневным прибыванием детей без сна в период каникул"]
["Возрастная категория: с 7 до 12 лет"]
[]
["Прием пищи","Наименование блюда","Выход блюда, в гр.","Пищевые вещества (г)",null,null,"Энергетическая ценность","№ рецептуры"]
[{"$nulls":3},"белки","жиры","углеводы","ккал"]
["ДЕНЬ 1"]
["Завтрак","Каша молочная ячневая со сливочным маслом","185/5/10",6.88,9.13,18.98,176,"№173"]
[null,"Яйцо отварное",40,6,5.5,0.3,78,"№209"]
[null,"Бутерброд с сыром","50/15",6.32,4.58,23.57,174.88,"№3"]
[null,"Какао с молоком",200,3.97,2.1,20.178,125.1,"№382"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D17+D16+D15+D14+D13","v":23.57},{"$f":"E17+E16+E15+E14+E13","v":21.71},72.828,605.98]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Оладьи ",100,9.48,7.49,31.85,264.81,"№406"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D20+D19","v":9.48},{"$f":"E20+E19","v":7.49},69.85,341.61]
["Обед","Салат из моркови с яблоком",60,0.59,3.78,5.19,55.85,"№59"]
[null,"Суп картофельный с бобовыми (гороховый) на мкб","235/15",3.77,6.25,14.94,148.97,"№102"]
[null,"Макароны отварные со сливочным маслом",150,5.47,6.37,34.34,204,"№203"]
[null,"Котлета из птицы",100,10.5,7.11,9.78,202,"№294"]
[null,"Соус томатный с овощами",30,0.3,1.47,1.95,21.6,"№333"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из сухофруктов",200,0.54,0,12.59,50.63,"№348"]
[null,"Итого за обед",null,{"$f":"D28+D27+D26+D25+D24+D23+D22","v":25.909999999999997},{"$f":"E28+E27+E26+E25+E24+E23+E22","v":26.73},104.91,819.1]
["Итого за  день:",null,null,{"$f":"D29+D21+D18","v":58.96},{"$f":"E29+E21+E18","v":55.93},{"$f":"F29+F21+F18","v":247.588},{"$f":"G29+G21+G18","v":1766.69}]
["ДЕНЬ 2"]
["Завтрак","Каша геркулесовая молочная со сливочным маслом","185/5/10",6.68,9.55,15.16,168.98,"№173"]
[null,"Запеканка творожная",65,13.12,3.55,11.29,144.02,"№223"]
[null,"Бутерброд с маслом","50/15",5.82,12.75,24.76,230,"№1"]
[null,"Чай с сахаром","190/10",0.021,0.005,9.985,40.1,"№376"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D36+D35+D34+D33+D32","v":26.041},{"$f":"E36+E35+E34+E33+E32","v":26.255},70.995,635.1]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D39+D38","v":4.75},{"$f":"E39+E38","v":7.9},55.05,285.3]
["Обед","Салат из свежих овощей",60,0.54,3.66,4.65,52.59,"№24"]
[null,"Борщ с капустой и картофелем на мкб со сметаной","225/15/10",8.07,7.89,20.64,180.77,"№82"]
[null,"Рис отварной",150,3.834,5.42,31.6,210,"№304"]
[null,"Рыба припущенная с овощами","80/40",7.52,5.63,10.21,139.2,"№229"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Кисель",200,0,0,30.95,98.1,"№359"]
[null,"Итого за обед",null,{"$f":"D46+D45+D44+D43+D42+D41+D45","v":29.444000000000003},{"$f":"E46+E45+E44+E43+E42+E41","v":24.35},124.17,816.71]
["Итого за  день:",null,null,{"$f":"D47+D40+D37","v":60.235},{"$f":"E47+E40+E37","v":58.504999999999995},{"$f":"F47+F40+F37","v":250.215},{"$f":"G47+G40+G37","v":1737.1100000000001}]
["ДЕНЬ 3"]
["Завтрак","Каша молочная гречневая со сливочным маслом","185/5/10",6.67,9.49,15.15,169.59,"№173"]
[null,"Омлет натуральный",80,5.22,5.51,4.7,103.92,"№120"]
[null,"Бутерброд с маслом и сыром","50/10/15",7.7,12.6,25.24,247.33,"№2"]
[null,"Чай с сахаром и урюком","180/10/7",0.2,1.5,10.71,45.4,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D54+D53+D52+D51+D50","v":20.189999999999998},{"$f":"E54+E53+E52+E51+E50","v":29.5},65.60000000000001,618.24]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D57+D56","v":4.75},{"$f":"E57+E56","v":7.9},55.05,285.3]
["Обед","Салат из белокочанной капусты",60,0.93,3.05,5.64,54,"№45"]
[null,"Суп с макаронными изделиями на курином бульоне со сметаной","225/15/10",8.04,6.1,24.75,187.5,"№112"]
[null,"Картофельное пюре",150,3.09,4.657,22.03,146,"№312"]
[null,"Котлета из говядины",100,10.16,13.92,13.52,236,"№268"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из свежих плодов",200,0.2,0.005,10.71,45.4,"№342"]
[null,"Итого за обед",null,{"$f":"D64+D63+D63+D62+D61+D60+D59","v":31.9},{"$f":"E64+E63+E62+E61+E60","v":26.432000000000002},{"$f":"F64+F63+F63+F62+F61+F60+F59","v":128.89},{"$f":"G64+G63+G62+G61+G60+G59","v":804.95}]
["Итого за  день:",null,null,{"$f":"D65+D58+D55","v":56.839999999999996},{"$f":"E65+E58+E55","v":63.832},{"$f":"F65+F58+F55","v":249.54000000000002},{"$f":"G65+G58+G55","v":1708.49}]
["ДЕНЬ 4"]
["Завтрак","Каша молочная \"Дружба\" со сливочным маслом","185/5/10",6.81,10.21,20.68,189.5,"№175"]
[null,"Яйцо отварное",40,6,5.5,0.3,78,"№209"]
[null,"Бутерброд с сыром","50/15",6.32,4.58,23.57,174.88,"№3"]
[null,"Чай с сахаром и лимоном","180/10/7",0.54,0.05,10.16,40.8,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D72+D71+D70+D69+D68","v":20.07},{"$f":"E72+E71+E70+E69+E68","v":20.740000000000002},64.50999999999999,{"$f":"G72+G72+G71+G70+G69+G68","v":587.1800000000001}]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Булочка домашняя",60,6.87,6.53,33.12,238,"№338"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D75+D74","v":6.87},{"$f":"E75+E74","v":6.53},71.12,314.8]
["Обед","Салат из отварной свеклы с черносливом",60,0.87,4.05,9.22,53.82,"№52"]
[null,"Рассольник Ленинградский на мкб со сметаной","225/15/10",8.7,7.05,14.65,175.54,"№96"]
[null,"Макароны отварные со сливочным маслом",150,5.47,6.37,34.34,204,"№203"]
[null,"Гуляш из куриных грудок","50/50",11.3,10.56,16.5,220.11,"№265"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из сухофруктов",200,0.54,0,12.59,50.63,"№348"]
[null,"Итого за обед",null,{"$f":"D82+D81+D80+D79+D78+D77","v":31.62},{"$f":"E82+E81+E80+E79+E78+E77","v":29.78},113.42000000000002,840.15]
["Итого за  день:",null,null,{"$f":"D83+D76+D73","v":58.56},{"$f":"E83+E76+E73","v":57.050000000000004},{"$f":"F83+F76+F73","v":249.05},{"$f":"G83+G76+G73","v":1742.13}]
["ДЕНЬ 5"]
["Завтрак","Каша молочная манная со сливочным маслом","185/5/10",6.37,11.76,22.75,181.11,"№181"]
[null,"Сырники творожные ","65",9.42,3.29,10.01,133.93,"№219"]
[null,"Бутерброд с маслом","50/15",5.82,12.75,24.76,230,"№1"]
[null,"Чай с сахаром","190/10",0.021,0.005,9.985,40.1,"№376"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D90+D89+D88+D87+D86","v":22.031000000000002},{"$f":"E90+E89+E88+E87+E86","v":28.205},77.305,637.1400000000001]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D93+D92","v":4.75},{"$f":"E93+E92","v":7.9},55.05,285.3]
["Обед","Салат из свежих помидор с репчатым луком",60,0.66,3.15,3.15,42.8,"№71"]
[null,"Щи с капустой и картофелем на мкб со сметаной","225/15/10",7.5,8.14,14.8,176.57,"№88"]
[null,"Картофель тушеный",150,7.38,4.6,25.46,212,"№142"]
[null,"Биточки рыбные из минтая",100,12.45,2.94,13.8,159.9,"№234"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Кисель",200,0,0,30.95,98.1,"№359"]
[null,"Итого за обед",null,{"$f":"D100+D99+D98+D97+D96+D95","v":32.72999999999999},{"$f":"E100+E99+E98+E97+E96+E95","v":20.58},114.28000000000002,825.4199999999998]
["Итого за  день:",null,null,{"$f":"D101+D94+D91","v":59.510999999999996},{"$f":"E101+E94+E91","v":56.684999999999995},{"$f":"F101+F94+F91","v":246.63500000000002},{"$f":"G101+G94+G91","v":1747.86}]
["ДЕНЬ 6"]
["Завтрак","Каша молочная рисовая со сливочным маслом","185/5/10",8.28,9.49,17,182.32,"№173"]
[null,"Бутерброд с маслом и сыром","50/10/15",7.7,12.6,25.24,247.33,"№2"]
[null,"Какао с молоком",200,3.97,2.1,20.178,125.1,"№382"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D107+D106++D106+D105+D104","v":24.32},{"$f":"E107+E106+E105+E104","v":24.59},72.218,606.75]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D110+D109","v":4.75},{"$f":"E110+E109","v":7.9},55.05,285.3]
["Обед","Салат из моркови с яблоком",60,0.59,3.78,5.19,55.85,"№59"]
[null,"Суп картофельный с клёцками на курином бульоне со сметаной","225/15/10",6.92,5.15,30.4,191.78,"№108"]
[null,"Каша гречневая рассыпчатая со сливочным маслом",150,6.86,7.58,33,170,"№171"]
[null,"Гуляш из говядины","50/50",9.75,12.5,7.985,216,"№260"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из свежих плодов",200,0.2,0.005,10.71,45.4,"№342"]
[null,"Итого за обед",null,{"$f":"D117+D116+D115+D114+D113+D112","v":29.06},{"$f":"E117+E116+E115+E114+E113+E112","v":30.765},113.405,815.08]
["Итого за  день:",null,null,{"$f":"D118+D111+D108","v":58.13},{"$f":"E118+E111+E108","v":63.254999999999995},{"$f":"F118+F111+F108","v":240.673},{"$f":"G118+G111+G108","v":1707.13}]
["ДЕНЬ 7"]
["Завтрак","Каша молочная пшенная со сливочным маслом","185/5/10",5.91,9.55,15.16,168.97,"№173"]
[null,"Омлет натуральный",80,5.22,5.51,4.7,103.92,"№120"]
[null,"Бутерброд с сыром","50/15",6.32,4.58,23.57,174.88,"№3"]
[null,"Чай с сахаром и урюком","180/10/7",0.2,1.5,10.71,45.4,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D125+D125+D124+D123+D122+D121","v":18.45},{"$f":"E125+E125+E124+E123+E122+E121","v":21.94},73.74000000000001,597.17]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Оладьи ",100,9.48,7.49,31.85,264.81,"№406"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D128+D127","v":9.48},{"$f":"E128+E127","v":7.49},69.85,341.61]
["Обед","Салат из свежих овощей",60,0.54,3.66,4.65,52.59,"№24"]
[null,"Суп картофельный с крупой (гречневый) на мкб","235/15",7.56,5.57,21.94,177.47,"№101"]
[null,"Рагу овощное с птицей",200,13.4,12.56,22.16,245.73,"№289"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из сухофруктов",200,0.54,0,12.59,50.63,"№348"]
[null,"Итого за обед",null,{"$f":"D134+D133+D132+D131+D130","v":26.779999999999998},{"$f":"E134+E133+E132+E131+E130+E130","v":27.200000000000003},{"$f":"F134+F134+F133+F132+F131+F130","v":100.05},{"$f":"G134+G133+G133+G132+G131+G130","v":798.5200000000001}]
["Итого за  день:",null,null,{"$f":"D135+D129+D126","v":54.709999999999994},{"$f":"E135+E129+E126","v":56.63000000000001},{"$f":"F135+F129+F126","v":243.64},{"$f":"G135+G129+G126","v":1737.3000000000002}]
["ДЕНЬ 8"]
["Завтрак","Каша геркулесовая молочная со сливочным маслом","185/5/10",6.68,9.55,15.16,168.98,"№173"]
[null,"Яйцо отварное",40,6,5.5,0.3,78,"№209"]
[null,"Бутерброд с маслом","50/15",5.82,12.75,24.76,230,"№1"]
[null,"Чай с сахаром и лимоном","180/10/7",0.54,0.05,10.16,40.8,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D142+D141+D140+D139+D139+D138","v":25.44},{"$f":"E142+E141+E140+E139+E138","v":28.25},60.17999999999999,{"$f":"G142+G141+G140+G139++G139+G138","v":647.78}]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5,"№338"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D145+D144","v":4.75},{"$f":"E145+E144","v":7.9},55.05,285.3]
["Обед","Огурцы свежие",60,0.45,0.07,1.5,8.4,"№71"]
[null,"Рассольник Ленинградский на мкб со сметаной","225/15/10",8.7,7.05,14.65,175.54,"№96"]
[null,"Макароны отварные со сливочным маслом",150,5.47,6.37,34.34,204,"№203"]
[null,"Тефтели мясные",100,9.99,13.4,24.4,204,"№279"]
[null,"Соус томатный с овощами",30,0.3,1.47,1.95,21.6,"№333"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Кисель",200,0,0,30.95,98.1,"№359"]
[null,"Итого за обед",null,{"$f":"D153+D152+D151+D150+D149+D148+D147","v":29.65},{"$f":"E153+E152+E151+E150+E148+E147","v":23.740000000000002},{"$f":"F153+F152+F151+F150+F149+F148+F147","v":133.91},847.6899999999999]
["Итого за  день:",null,null,{"$f":"D154+D146+D143","v":59.84},{"$f":"E154+E146+E143","v":59.89},{"$f":"F154+F146+F143","v":249.14},{"$f":"G154+G146+G143","v":1780.77}]
["ДЕНЬ 9"]
["Завтрак","Каша молочная ячневая со сливочным маслом","185/5/10",6.88,9.13,18.98,176,"№173"]
[null,"Бутерброд с маслом и сыром","50/10/15",7.7,12.6,25.24,247.33,"№2"]
[null,"Какао с молоком",200,3.97,2.1,20.178,125.1,"№382"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D160+D159+D158+D157","v":18.95},{"$f":"E160+E159+E158+E157","v":24.23},74.19800000000001,600.4300000000001]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D163+D162","v":4.75},{"$f":"E163+E162","v":7.9},55.05,285.3]
[]
["Обед","Салат из отварной свеклы с черносливом",60,0.87,4.05,9.22,53.82,"№52"]
[null,"Щи с капустой и картофелем на мкб со сметаной","225/15/10",7.5,8.14,14.8,176.57,"№88"]
[null,"Картофельное пюре",150,3.09,4.657,22.03,146,"№312"]
[null,"Кнели куриные",100,12.63,10.6,6.95,228,"№301"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из свежих плодов",200,0.2,0.005,10.71,45.4,"№342"]
[null,"Итого за обед",null,{"$f":"D171+D170+D170+D169+D168+D167+D166","v":33.77},{"$f":"E171+E171+E170+E169+E168+E167+E166","v":29.207},{"$f":"F171+F171+F170+F168+F168+F167+F166","v":115.62},831.2400000000001]
["Итого за  день:",null,null,{"$f":"D172+D164+D161","v":57.47},{"$f":"E172+E164+E161","v":61.337},{"$f":"F172+F164+F161","v":244.86800000000002},{"$f":"G172+G164+G161","v":1716.9700000000003}]
["ДЕНЬ 10"]
["Завтрак","Каша молочная манная со сливочным маслом","185/5/10",6.37,11.76,22.75,181.11,"№181"]
[null,"Сырники творожные ","65",9.42,3.29,10.01,133.93,"№219"]
[null,"Бутерброд с сыром","50/15",6.32,4.58,23.57,174.88,"№3"]
[null,"Чай с сахаром","190/10",0.021,0.005,9.985,40.1,"№376"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D179+D178+D177+D176+D175","v":22.531000000000002},{"$f":"E179+E178+E177+E176+E175","v":20.035},76.11500000000001,582.02]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Слойка с сахаром",60,9.63,9.41,30.18,255.34,"№417"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D182+D181","v":9.63},{"$f":"E182+E181","v":9.41},68.18,332.14]
["Обед","Салат из белокочанной капусты",60,0.93,3.05,5.64,54,"№45"]
[null,"Суп картофельный с крупой (гречневый) на мкб","235/15",7.56,5.57,21.94,177.47,"№101"]
[null,"Рис отварной",150,3.834,5.42,31.6,210,"№304"]
[null,"Рыба припущенная с овощами","80/40",7.52,5.63,10.21,139.2,"№229"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из сухофруктов",200,0.54,0,12.59,50.63,"№348"]
[null,"Итого за обед",null,{"$f":"D189+D188+D187+D186+D185+D184","v":25.124},{"$f":"E189+E188+E187+E187+E186+E185+E184","v":27.05},{"$f":"F189+F188+F186+F185+F184","v":97.89},{"$f":"G189++G189+G188+G187+G186+G185+G184","v":817.98}]
["Итого за  день:",null,null,{"$f":"D190+D183+D180","v":57.285},{"$f":"E190+E183+E180","v":56.495000000000005},{"$f":"F190+F183+F180","v":242.185},{"$f":"G190+G183+G180","v":1732.1399999999999}]
["ДЕНЬ 11"]
["Завтрак","Каша молочная \"Дружба\" со сливочным маслом","185/5/10",6.81,10.21,20.68,189.5,"№175"]
[null,"Омлет натуральный",80,5.22,5.51,4.7,103.92,"№120"]
[null,"Бутерброд с маслом","50/15",5.82,12.75,24.76,230,"№1"]
[null,"Чай с сахаром и урюком","180/10/7",0.2,1.5,10.71,45.4,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D197+D196+D195+D194+D194+D193","v":23.669999999999998},{"$f":"E197+E196+E195+E194+E193","v":30.37},70.65,620.8199999999999]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5,"№338"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D200+D199","v":4.75},{"$f":"E200+E199","v":7.9},55.05,285.3]
["Обед","Помидоры свежие",60,0.67,0.15,3.15,14.4,"№71"]
[null,"Борщ с капустой и картофелем на мкб со сметаной","225/15/10",8.07,7.89,20.64,180.77,"№82"]
[null,"Макароны отварные со сливочным маслом",150,5.47,6.37,34.34,204,"№203"]
[null,"Котлета из птицы",100,10.5,7.11,9.78,202,"№294"]
[null,"Соус томатный с овощами",30,0.3,1.47,1.95,21.6,"№333"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Кисель",200,0,0,30.95,98.1,"№359"]
[null,"Итого за обед",null,{"$f":"D208+D207+D206+D205+D204+D203+D202","v":29.75},{"$f":"E208+E207+E206+E205+E204+E203+E202","v":24.74},126.93,856.92]
["Итого за  день:",null,null,{"$f":"D209+D201+D198","v":58.17},{"$f":"E209+E201+E198","v":63.010000000000005},{"$f":"F209+F201+F198","v":252.63000000000002},{"$f":"G209+G201+G198","v":1763.04}]
["ДЕНЬ 12"]
["Завтрак","Каша геркулесовая молочная со сливочным маслом","185/5/10",6.68,9.55,15.16,168.98,"№173"]
[null,"Бутерброд с маслом и сыром","50/10/15",7.7,12.6,25.24,247.33,"№2"]
[null,"Какао с молоком",200,3.97,2.1,20.178,125.1,"№382"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D215+D214+D213+D212","v":18.75},{"$f":"E215+E214+E213+E212","v":24.65},70.378,593.41]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D218+D217","v":4.75},{"$f":"E218+E217","v":7.9},55.05,285.3]
["Обед","Салат из моркови с яблоком",60,0.59,3.78,5.19,55.85,"№59"]
[null,"Суп с макаронными изделиями на курином бульоне со сметаной","225/15/10",8.04,6.1,24.75,187.5,"№112"]
[null,"Гороховое пюре",150,5.12,5.82,28.15,205,"№306"]
[null,"Котлета из говядины",100,10.16,13.92,13.52,236,"№268"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из свежих плодов",200,0.2,0.005,10.71,45.4,"№342"]
[null,"Итого за обед",null,{"$f":"D225+D224+D224+D223+D222+D221+D220","v":33.59},{"$f":"E225+E223+E222+E221+E220","v":29.625},{"$f":"F225+F225+F224+F223+F222+F221+F220","v":119.15},{"$f":"G225+G224+G223+G222+G221+G220","v":865.8000000000001}]
["Итого за  день:",null,null,{"$f":"D226+D219+D216","v":57.09},{"$f":"E226+E219+E216","v":62.175},{"$f":"F226+F219+F216","v":244.57799999999997},{"$f":"G226+G219+G216","v":1744.5100000000002}]
["ДЕНЬ 13"]
["Завтрак","Каша молочная гречневая со сливочным маслом","185/5/10",6.67,9.49,15.15,169.59,"№173"]
[null,"Яйцо отварное",40,6,5.5,0.3,78,"№209"]
[null,"Бутерброд с сыром","50/15",6.32,4.58,23.57,174.88,"№3"]
[null,"Чай с сахаром и лимоном","180/10/7",0.54,0.05,10.16,40.8,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D233+D232+D231+D230+D229","v":19.93},{"$f":"E233+E232+E231+E230+E229","v":20.020000000000003},58.98,{"$f":"G233+G232+G231+G230+G229+G230","v":593.27}]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Оладьи ",100,9.48,7.49,31.85,264.81,"№406"]
[null,"Итого за 2-ой завтрак",null,{"$f":"D236+D235","v":9.48},{"$f":"E236+E235","v":7.49},69.85,341.61]
["Обед","Салат из отварной свеклы с черносливом",60,0.87,4.05,9.22,53.82,"№52"]
[null,"Рассольник Ленинградский на мкб со сметаной","225/15/10",8.7,7.05,14.65,175.54,"№96"]
[null,"Жаркое из птицы",200,12.84,8.87,31.07,247.72,"ТТК №50"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Компот из сухофруктов",200,0.54,0,12.59,50.63,"№348"]
[null,"Итого за обед",null,{"$f":"D242+D241+D240+D239+D238","v":27.69},{"$f":"E242+E241+E240+E239++E239+E238","v":28.77},{"$f":"F242+F241+F240+F239++F239+F238","v":108.30000000000001},839.3]
["Итого за  день:",null,null,{"$f":"D243+D237+D234","v":57.1},{"$f":"E243+E237+E234","v":56.28},{"$f":"F243+F237+F234","v":237.13},{"$f":"G243+G237+G234","v":1774.1799999999998}]
["ДЕНЬ 14"]
["Завтрак","Каша молочная \"Дружба\" со сливочным маслом","185/5/10",6.81,10.21,20.68,189.5,"№175"]
[null,"Омлет натуральный",80,5.22,5.51,4.7,103.92,"№120"]
[null,"Бутерброд с маслом","50/15",5.82,12.75,24.76,230,"№1"]
[null,"Чай с сахаром и урюком","180/10/7",0.2,1.5,10.71,45.4,"№377"]
[null,"Фрукт",100,0.4,0.4,9.8,52,"№338"]
[null,"Итого за завтрак",null,{"$f":"D250+D249+D248+D247+D246","v":18.45},{"$f":"E250+E249+E248+E247+E246","v":30.37},70.65,620.8199999999999]
["2-ой завтрак","Сок",200,0,0,38,76.8,"№389"]
[null,"Кондитерское изделие",50,4.75,7.9,17.05,208.5]
[null,"Итого за 2-ой завтрак",null,{"$f":"D253+D252","v":4.75},{"$f":"E253+E252","v":7.9},55.05,285.3]
["Обед","Салат из свежих овощей",60,0.54,3.66,4.65,52.59,"№24"]
[null,"Щи с капустой и картофелем на мкб со сметаной","225/15/10",7.5,8.14,14.8,176.57,"№88"]
[null,"Картофельное пюре",150,3.09,4.657,22.03,146,"№312"]
[null,"Биточки рыбные из минтая",100,12.45,2.94,13.8,159.9,"№234"]
[null,"Хлеб ржаной",70,4.74,1.75,26.12,136.05]
[null,"Кисель",200,0,0,30.95,98.1,"№359"]
[null,"Итого за обед",null,{"$f":"D260+D259+D259+D258+D257+D256+D255","v":33.059999999999995},{"$f":"E260+E258+E257+E256+E255","v":19.397},{"$f":"F260+F259+F258+F257+F256+F255+F255","v":117.00000000000001},{"$f":"G260+G259+G258+G257+G256+G255+G255","v":821.8}]
["Итого за  день:",null,null,{"$f":"D261+D254+D251","v":56.25999999999999},{"$f":"E261+E254+E251","v":57.667},{"$f":"F261+F254+F251","v":242.70000000000002},{"$f":"G261+G254+G251","v":1727.9199999999998}]

{"sheet":"Пищевая ценность","index":3,"n_rows":75,"n_cols":6,"rows_kept":75,"merged":[[46,0,47,0],[48,0,49,0],[50,0,51,0],[52,0,53,0],[54,0,55,0],[56,0,57,0],[58,0,59,0],[60,0,61,0],[62,0,63,0],[64,0,65,0],[66,0,67,0],[68,0,69,0],[70,0,71,0],[72,0,73,0]]}
["СЛИЧИТЕЛЬНЫЙ ЛИСТ ПИЩЕВОЙ И ЭНЕРГЕТИЧЕСКИЙ ЦЕННОСТИ ПО ИТОГАМ ДНЯ"]
[]
["День","Белки","жиры ","углеводы","ккал"]
["ДЕНЬ 1",58.96,55.93,247.588,1766.69]
["ДЕНЬ 2",60.235,58.504999999999995,250.215,1737.1100000000001]
["ДЕНЬ 3",56.839999999999996,63.832,249.54000000000002,1708.49]
["ДЕНЬ 4",58.56,57.050000000000004,249.05,1742.13]
["ДЕНЬ 5",59.510999999999996,56.684999999999995,246.63500000000002,1747.86]
["ДЕНЬ 6",58.13,63.254999999999995,240.673,1707.13]
["ДЕНЬ 7",54.709999999999994,56.63000000000001,243.64,1737.3000000000002]
["ДЕНЬ 8",59.84,59.89,249.14,1780.77]
["ДЕНЬ 9",57.47,61.337,244.86800000000002,1716.9700000000003]
["ДЕНЬ 10",57.285,56.495000000000005,242.185,1732.1399999999999]
["ДЕНЬ 11",58.17,63.010000000000005,252.63000000000002,1763.04]
["ДЕНЬ 12",57.09,62.175,244.57799999999997,1744.5100000000002]
["ДЕНЬ 13",57.1,56.28,237.13,1774.1799999999998]
["ДЕНЬ 14",56.25999999999999,57.667,242.70000000000002,1727.9199999999998]
["Итого за 14 дней",{"$f":"B17+B16+B15+B14+B13+B12+B11+B10+B9+B8+B7+B6+B5+B4","v":810.1610000000001},{"$f":"C17+C16+C15+C14+C13+C12+C11+C10+C9+C8+C7+C6+C5+C4","v":828.7409999999999},3440.5720000000006,24386.24]
["Среднесуточные данные",57.86,59.19,245.75,1741.87]
["Норма СанПиН 2.3/2.4.3590-20 в сутки",77,79,335,2350]
["Норма  не менее 70% (70-75%)","53,9-57,75","55,3-59,25","234,5-251,25","1645-1762,5"]
[]
[]
["СУММАРНЫЕ ОБЪЁМЫ БЛЮД ПО ПРИЁМАМ ПИЩИ"]
[]
["Наименование","Завтрак","2-ой завтрак","Обед"]
["День 1",605,300,860]
["День 2",630,250,850]
["День 3",652,250,830]
["День 4",602,260,830]
["День 5",625,250,830]
["День 6",575,250,830]
["День 7",642,300,780]
["День 8",602,250,860]
["День 9",575,250,830]
["День 10",630,260,850]
["День 11",642,250,860]
["День 12",575,250,830]
["День 13",602,300,780]
["День 14",643,250,830]
["Нормы СанПиН не менее",500,200,700]
[]
[]
["РАСПРЕДЕЛЕНИЕ КАЛОРИЙНОСТИ ПО ПРИЁМАМ ПИЩИ"]
[]
["Наименование",null,"Завтрак","2-ой завтрак","Обед","Итого"]
["День 1","Ккал",605.98,341.61,819.1,{"$f":"C47+D47+E47","v":1766.69}]
[null,"% от сут нормы",{"v":0.2578,"d":"25.78%"},{"v":0.1453,"d":"14.53%"},{"v":0.3485,"d":"34.85%"},{"$f":"C48+D48+E48","v":{"v":0.7516,"d":"75.16%"}}]
["День 2","Ккал",635.1,285.3,816.71,1737.1100000000001]
[null,"% от сут нормы",{"v":0.27,"d":"27.00%"},{"v":0.1214,"d":"12.14%"},{"v":0.3475,"d":"34.75%"},{"v":0.7389,"d":"73.89%"}]
["День 3","Ккал",618.24,285.3,804.95,1708.49]
[null,"% от сут нормы",{"v":0.263,"d":"26.30%"},{"v":0.1214,"d":"12.14%"},{"v":0.3425,"d":"34.25%"},{"v":0.7269000000000001,"d":"72.69%"}]
["День 4","Ккал",587.18,314.8,840.15,1742.13]
[null,"% от сут нормы",{"v":0.25,"d":"25.00%"},{"v":0.134,"d":"13.40%"},{"v":0.3575,"d":"35.75%"},{"v":0.7415,"d":"74.15%"}]
["День 5","Ккал",637.14,285.3,825.42,{"$f":"C55+D55+E55","v":1747.8600000000001}]
[null,"% от сут нормы",{"v":0.2711,"d":"27.11%"},{"v":0.1214,"d":"12.14%"},{"v":0.3512,"d":"35.12%"},{"v":0.7437,"d":"74.37%"}]
["День 6","Ккал",606.75,285.3,815.08,1707.13]
[null,"% от сут нормы",{"v":0.2581,"d":"25.81%"},{"v":0.1214,"d":"12.14%"},{"v":0.3468,"d":"34.68%"},{"v":0.7263,"d":"72.63%"}]
["День 7","Ккал",597.17,341.61,798.52,{"$f":"C59+D59+E59","v":1737.3}]
[null,"% от сут нормы",{"v":0.2574,"d":"25.74%"},{"v":0.1453,"d":"14.53%"},{"v":0.34,"d":"34.00%"},{"v":0.7427000000000001,"d":"74.27%"}]
["День 8","Ккал",647.78,285.3,847.69,1780.77]
[null,"% от сут нормы",{"v":0.2756,"d":"27.56%"},{"v":0.1214,"d":"12.14%"},{"v":0.36,"d":"36.00%"},{"v":0.757,"d":"75.70%"}]
["День 9","Ккал",600.43,285.3,831.24,1716.97]
[null,"% от сут нормы",{"v":0.2555,"d":"25.55%"},{"v":0.1214,"d":"12.14%"},{"v":0.3537,"d":"35.37%"},{"v":0.7306,"d":"73.06%"}]
["День 10","Ккал",582.02,332.14,817.98,1732.1399999999999]
[null,"% от сут нормы",{"v":0.2476,"d":"24.76%"},{"v":0.1413,"d":"14.13%"},{"v":0.348,"d":"34.80%"},{"v":0.7369,"d":"73.69%"}]
["День 11","Ккал",620.82,285.3,856.92,1763.04]
[null,"% от сут нормы",{"v":0.264,"d":"26.40%"},{"v":0.1214,"d":"12.14%"},{"v":0.3646,"d":"36.46%"},{"v":0.75,"d":"75.00%"}]
["День 12","Ккал",593.41,285.3,865.8,1744.51]
[null,"% от сут нормы",{"v":0.2525,"d":"25.25%"},{"v":0.1214,"d":"12.14%"},{"v":0.3684,"d":"36.84%"},{"v":0.7423,"d":"74.23%"}]
["День 13","Ккал",593.27,341.61,839.3,1774.1799999999998]
[null,"% от сут нормы",{"v":0.2524,"d":"25.24%"},{"v":0.1453,"d":"14.53%"},{"v":0.357,"d":"35.70%"},{"v":0.7547,"d":"75.47%"}]
["День 14","Ккал",620.82,285.3,821.8,1727.92]
[null,"% от сут нормы",{"v":0.264,"d":"26.40%"},{"v":0.1214,"d":"12.14%"},{"v":0.3498,"d":"34.98%"},{"v":0.7352000000000001,"d":"73.52%"}]
["Рекомендуемые нормы СанПиН ",null,{"v":0.25,"d":"25.00%"},null,{"v":0.35,"d":"35.00%"}]